﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using XBLib.Dal;
using XBLib.Dal.AdoDal;
using XBLib.BusinessObject;

using System.Data.Common;
using DataInfo;
using System.Data.SqlTypes;
using System.Data.SqlClient;

namespace KenLib.Dal
{
    class frmO_EmpBasicInfoDao : BaseAdoDao
    {
        public DataSet select基本情報by社員ID(Int32 id)
        {
            DbParameter pr_社員ID = _daoHelper.CreateParameter("@社員ID", id);
            DbCommand db_c = _daoHelper.CreateCommand("select基本情報by社員ID_Thanh", CommandType.StoredProcedure, pr_社員ID);
            SqlCommand db_Command = new SqlCommand();
            db_Command = (SqlCommand)db_c;
            SqlDataAdapter dtA = new SqlDataAdapter(db_Command);
            DataSet dts = new DataSet();
            dtA.Fill(dts);
            dts.Tables[0].TableName = "基本情報";
            dts.Tables[1].TableName = "入退社情報";
            dts.Tables[2].TableName = "雇用情報";
            dts.Tables[3].TableName = "資格情報";
            dts.Tables[4].TableName = "所属情報";
            dts.Tables[5].TableName = "職種職務情報";
            dts.Tables[10].TableName = "保有資格情報";
            dts.Tables[11].TableName = "業務スキル情報";
            dts.Tables[12].TableName = "賞罰情報";
            dts.Tables[14].TableName = "学歴情報";
            dts.Tables[15].TableName = "職歴情報";
            return dts;
        }
    }
}
